SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
CREATE TABLE [dbo].[Users]( 
[UserName] [nvarchar](20) NOT NULL,
[UserNameLowered] [nvarchar](20) NOT NULL,
[Email] [nvarchar](30) NOT NULL,
[EmailLowered] [nvarchar](30) NOT NULL,
[Password] [nvarchar](100) NOT NULL,
[Roles] [nvarchar](50) NULL,
[MobilePhone] [nvarchar](20) NOT NULL,
[SecurityQuestion] [nvarchar](150) NULL,
[SecurityAnswer] [nvarchar](150) NULL,
[Comment] [nvarchar](50) NULL,
[IsApproved] [bit] NULL,
[IsLockedOut] [bit] NULL,
[LockOutReason] [nvarchar](50) NULL,
[LastLoginDate] [datetime] NOT NULL,
[LastPasswordChangedDate] [datetime] NOT NULL,
[LastPasswordResetDate] [datetime] NOT NULL,
[LastLockOutDate] [datetime] NOT NULL,
[Id] [int] IDENTITY(1,1) NOT NULL,
[CreateDate] [datetime] NOT NULL,
[UpdateDate] [datetime] NOT NULL,
[CreateUser] [nvarchar](20) NOT NULL,
[UpdateUser] [nvarchar](20) NOT NULL,
[UpdateComment] [nvarchar](150) NULL,
[Version] [int] NOT NULL,
[IsActive] [bit] NOT NULL,
 CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED 
( [Id] ASC
 )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 ) ON [PRIMARY] 
